package com.sky.service.impl;

import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;
import com.sky.constant.MessageConstant;
import com.sky.constant.PasswordConstant;
import com.sky.constant.StatusConstant;
import com.sky.context.BaseContext;
import com.sky.dto.EmployeeDTO;
import com.sky.dto.EmployeeLoginDTO;
import com.sky.dto.EmployeePageQueryDTO;
import com.sky.entity.Employee;
import com.sky.exception.AccountLockedException;
import com.sky.exception.AccountNotFoundException;
import com.sky.exception.PasswordErrorException;
import com.sky.mapper.EmployeeMapper;
import com.sky.result.PageResult;
import com.sky.service.EmployeeService;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.DigestUtils;

import java.time.LocalDateTime;
import java.util.Date;
import java.util.List;

@Service
public class EmployeeServiceImpl implements EmployeeService {

    @Autowired
    private EmployeeMapper employeeMapper;

    /**
     * 员工登录
     *
     * @param employeeLoginDTO
     * @return
     */
    public Employee login(EmployeeLoginDTO employeeLoginDTO) {
        String username = employeeLoginDTO.getUsername();
        String password = employeeLoginDTO.getPassword();

        //1、根据用户名查询数据库中的数据
        Employee employee = employeeMapper.getByUsername(username);

        //2、处理各种异常情况（用户名不存在、密码不对、账号被锁定）
        if (employee == null) {
            //账号不存在
            throw new AccountNotFoundException(MessageConstant.ACCOUNT_NOT_FOUND);
        }

        //密码比对
        // 使用md5算法进行加密后与数据库中的密码进行比对。但：md5已被证实存在碰撞漏洞，待优化
        password = DigestUtils.md5DigestAsHex(password.getBytes());
        if (!password.equals(employee.getPassword())) {
            //密码错误
            throw new PasswordErrorException(MessageConstant.PASSWORD_ERROR);
        }

        if (employee.getStatus() == StatusConstant.DISABLE) {
            //账号被锁定
            throw new AccountLockedException(MessageConstant.ACCOUNT_LOCKED);
        }

        //3、返回实体对象
        return employee;
    }

    /**
     * 新增员工
     * @param employeeDTO
     */
    @Override
    public void save(EmployeeDTO employeeDTO) {
        //将数据传输对象中的属性拷贝到实体对象中
        Employee employee = new Employee();
        BeanUtils.copyProperties(employeeDTO, employee);

        //默认状态为1，即正常状态
            employee.setStatus(StatusConstant.ENABLE);

        //默认密码为123456，加密后存入数据库
        employee.setPassword(DigestUtils.md5DigestAsHex(PasswordConstant.DEFAULT_PASSWORD.getBytes()));

        employeeMapper.insert(employee);
    }

    /**
     * 分页查询员工
     * @param queryDTO
     * @return
     */
    public PageResult queryEmployeePage(EmployeePageQueryDTO queryDTO) {
        //借用pageHelper插件进行分页操作。pageHelper的startPage是将参数注入到ThreadLocal中，
        //在之后执行sql语句时自动进行动态sql拼接，所以无需额外传参和配置
        PageHelper.startPage(queryDTO.getPage(), queryDTO.getPageSize());
        Page<Employee> page = employeeMapper.selectEmployeePage(queryDTO);
        List<Employee> records = page.getResult();
        long total = page.getTotal();
        return new PageResult(total,records);
    }

    /**
     * 启用或禁用员工账号
     * @param status
     * @param id
     */
    @Override
    public void startOrStop(Integer status, long id) {
        //修改员工账号状态为0或1，可以不单独创建mapper方法，而是使用update+动态sql
        Employee employee = Employee.builder()
                .id(id)
                .status(status).build();
        employeeMapper.updateById(employee);
    }

    /**
     * 根据id查询员工
     * @param id
     * @return
     */
    public Employee getEmployeeById(long id) {
        Employee employee = employeeMapper.getById(id);
        if (employee == null) {
            throw new AccountNotFoundException(MessageConstant.ACCOUNT_NOT_FOUND);
        }
        return employee;
    }

    /**
     * 更新员工信息
     * @param employeeDTO
     */
    public void updateEmployee(EmployeeDTO employeeDTO) {
        Employee employee = new Employee();
        BeanUtils.copyProperties(employeeDTO, employee);
        employeeMapper.updateById(employee);
    }

}
